• Oracle sequences: The basics

    Updated: 2021-03-26 18:06:05
    Oracle sequences can be used to create artificial IDs for a table. In this article, Jonathan Lewis explains how they work under-the-hood.… The post Oracle sequences: The basics appeared first on Simple Talk.

  • A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II

    Updated: 2021-03-26 14:40:20
    In this article, Shel Burkow uses the SQL execution plan from the previous article to write a program in Scala.… The post A data transformation problem in SQL and Scala: Dovetailing declarative solutions Part II appeared first on Simple Talk.

  • SQL SERVER – Enable Adaptive Join

    Updated: 2021-03-25 10:30:07
    Let us learn how we can enable the adaptive join feature in SQL Server. I often discuss this during Comprehensive Database Performance Health Check. First appeared on SQL SERVER – Enable Adaptive Join

  • What to monitor for SQL Server security

    Updated: 2021-03-24 18:35:30
    Keeping databases secure is critical. In this article, Robert Sheldon explains what to monitor for SQL Server security.… The post What to monitor for SQL Server security appeared first on Simple Talk.

  • SQL SERVER – Adaptive Threshold Rows

    Updated: 2021-03-24 10:30:11
    Today we are going to learn about what drives the decision to join Adaptive Join. Well, the answer is very simple - Adaptive Threshold Rows. First appeared on SQL SERVER – Adaptive Threshold Rows

  • SQL SERVER – Table or View – OBJECTPROPERTY

    Updated: 2021-03-23 10:30:35
    Let us learn how I use a quick trick to know the object property with the keyword OBJECTPROPERTY. Let us learn how we can figure it out. First appeared on SQL SERVER – Table or View – OBJECTPROPERTY

  • Mastering TempDB: Managing TempDB growth

    Updated: 2021-03-22 19:27:05
    Out-of-control tempdb growth must be managed to keep the server running. Monica Rathbun gives her strategy to handle unexpected tempdb growth. … The post Mastering TempDB: Managing TempDB growth appeared first on Simple Talk.

  • Find Expensive Queries – SQL in Sixty Seconds #159

    Updated: 2021-03-22 10:30:46
    Earlier I wrote a blog post about SQL SERVER – List Expensive Queries – Updated March 2021. Let us learn how to Find Expensive Queries. First appeared on Find Expensive Queries – SQL in Sixty Seconds #159

  • SQL SERVER – Maximum Column Per Index – 32

    Updated: 2021-03-21 10:30:17
    Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today. First appeared on SQL SERVER – Maximum Column Per Index – 32

  • What is interpolation?

    Updated: 2021-03-11 16:12:26
    In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.… The post What is interpolation? appeared first on Simple Talk.

  • How SQL Server synonyms help database DevOps

    Updated: 2021-03-05 01:09:36
    Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database level object that allows you to provide an alternative name for another database object such as a view, user defined table, scalar function, stored procedure, inline table valued function (tvf), or extended stored procedure. They can also be … The post How SQL Server synonyms help database DevOps appeared first on Simple Talk.

Previous Months Items

Feb 2021